UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TfPPqsYH4zPNPZQ9eaJW12mSLE7LM1HS9SOf61CEqV4='
WHERE
key_id = '6c0a32f9ba1f589e8bc8e04c8e8417bf19045bf282616871852e399603aa349d'
AND (
token = 'TfPPqsYH4zPNPZQ9eaJW12mSLE7LM1HS9SOf61CEqV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)