UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AQIsS6wmlD1keckMXFuvJWpqUgrbw8MlgA0VLsFsPcU='
WHERE
key_id = '472f6f29298444febd537ef1b2c5b40785654568d037c714c4a247ea38937848'
AND (
token = 'AQIsS6wmlD1keckMXFuvJWpqUgrbw8MlgA0VLsFsPcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)