UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v4Z1LH8phNigEN4XfHWgnE7J2mu6tIurj6ntdbPbCRg='
WHERE
key_id = 'f89c4da2c239e5871bbcb396d580f5e54691fc3347906fa7bf701d9f2a5802fb'
AND (
token = 'v4Z1LH8phNigEN4XfHWgnE7J2mu6tIurj6ntdbPbCRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)