UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bj7G1G+qaSY8fYQKhwyUtVpGpH8oUZRoSTW4G8d9dvM='
WHERE
key_id = '3d0dc4845c4732ee217102ded80945a5955608bb8d8c8b4f330f3539c19da5d4'
AND (
token = 'bj7G1G+qaSY8fYQKhwyUtVpGpH8oUZRoSTW4G8d9dvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)