UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4TgriEjGN+7Ja5IhSSbuy8sTgZLxkSDIHLycUF3YHD8='
WHERE
key_id = '810d14df50f2c0dfcafc06c115ef7270bb2a5b0779279886fea0d7d618df8511'
AND (
token = '4TgriEjGN+7Ja5IhSSbuy8sTgZLxkSDIHLycUF3YHD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)