UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IB6BJLW+o4YrySGxbAj1DXV0dI7p9J+amLH2BCnRam8='
WHERE
key_id = 'f6b554cd5e036bd2f175ff475fad2ac6b2f21960781219b5db73a1dc6ccb7145'
AND (
token = 'IB6BJLW+o4YrySGxbAj1DXV0dI7p9J+amLH2BCnRam8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)