UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVg6lCvxcYSa9OHGHJwSRJEeo+8rQ81gmQP3Ro3b2H4='
WHERE
key_id = '9c3cecbb9f60bbe51d88c716b9b2dcb3eac97f6fcd205b6afa9f464a3e021bd7'
AND (
token = 'XVg6lCvxcYSa9OHGHJwSRJEeo+8rQ81gmQP3Ro3b2H4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)