UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AQI1r3QwhVSIjR8RYdLvBNldJdApY67gqBV7A8cCeu8='
WHERE
key_id = 'e787eff1cef3568df2891111a5323ba0b51104adf279f675eae97948bbcdf4b1'
AND (
token = 'AQI1r3QwhVSIjR8RYdLvBNldJdApY67gqBV7A8cCeu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)