UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MgoRUE5VU02pJ0BLQsuGALdWTcykbTJn+2frWf7VX7A='
WHERE
key_id = '7c83004bb909da288d301e884374e73778c179b5e27f4cfe11e6a997840b2e04'
AND (
token = 'MgoRUE5VU02pJ0BLQsuGALdWTcykbTJn+2frWf7VX7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)