UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XTekU6YJFX04qYk3MylfGt1O/6VHA7Hfs4AGVUIZ8qY='
WHERE
key_id = '6c8e282064ab3cf40d9d88eb14c08a153bdd02d80c32584c2c6eec004ad3c10d'
AND (
token = 'XTekU6YJFX04qYk3MylfGt1O/6VHA7Hfs4AGVUIZ8qY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)