UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5R7g3LqZlXFW1dAeB4ervoHdMpJlRXHP9y1WDKZklEA='
WHERE
key_id = '8b31c780edac10e575f9b2a315c37c0b163c99aef71d6281e61d25d7324bf011'
AND (
token = '5R7g3LqZlXFW1dAeB4ervoHdMpJlRXHP9y1WDKZklEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)