UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uoMOSoC+g5gHw2QL7s7QziUPVuepvBm70uaweYX0SH0='
WHERE
key_id = 'be46e7e3248aa72d1d25e5b5de347cd9f8ddbf6e9b60e95b48a9a1905b69e5a4'
AND (
token = 'uoMOSoC+g5gHw2QL7s7QziUPVuepvBm70uaweYX0SH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)