UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gvrvoy3zCm8c7WCVkFFIPrmU8OII5Iy3Vxsl2oWcVCs='
WHERE
key_id = 'a2483346ddb19362ee1e80fdfaa43b99773df4866e267165f53ffb3434da7478'
AND (
token = 'gvrvoy3zCm8c7WCVkFFIPrmU8OII5Iy3Vxsl2oWcVCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)