UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rTYoiMbPMFIhQUGV+9JXtYITLp8wY9DwwvGevFrGRRQ='
WHERE
key_id = 'fb3a8c0757a6a909cd9decb0b43edc574426db1699e6f65a53015de6fd4dc9ab'
AND (
token = 'rTYoiMbPMFIhQUGV+9JXtYITLp8wY9DwwvGevFrGRRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)