UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BswrbacIfBWUFtTerJ8kEtwG9xwYi8731Jh2k+P0HA8='
WHERE
key_id = '2c11190bee17d0805801dd0d0560040455539666ad7e6ac1bea8eeae39efe3fb'
AND (
token = 'BswrbacIfBWUFtTerJ8kEtwG9xwYi8731Jh2k+P0HA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)