UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LsXQb1AUkxKiqKOvdlJs5UK4OXK4RfUOUhmHvoL4UZE='
WHERE
key_id = '9243b0e540f152749f5b2cb18bdc499fb3bd4a582c6ffe0aeea24b83eb5ec314'
AND (
token = 'LsXQb1AUkxKiqKOvdlJs5UK4OXK4RfUOUhmHvoL4UZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)