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