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