UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3J6AVeUAo5Nct/AfoN02hz4vMafLNlFcGNB92O0XAwU='
WHERE
key_id = 'ab05c01529a83075cc4f6272b8efb55189a0443f03b2a9d9500d885221fefa99'
AND (
token = '3J6AVeUAo5Nct/AfoN02hz4vMafLNlFcGNB92O0XAwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)