UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEsFSEdMcSU5idn7Tbwikm42Ad2SagtH/teqt3+kDrY='
WHERE
key_id = 'a9ff3cfbc5b899af80ba9d2d79e996b3e7f70a4cb7d5746894f7412c01f243a8'
AND (
token = 'pEsFSEdMcSU5idn7Tbwikm42Ad2SagtH/teqt3+kDrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)