UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4xUg3mGMno8w+u3JnsWf5vp5F0q6+2Vi4er5pDKAHDw='
WHERE
key_id = '04d64b030675dab34347d445060c596bd69ff99372ca9a9924fccc97257d366f'
AND (
token = '4xUg3mGMno8w+u3JnsWf5vp5F0q6+2Vi4er5pDKAHDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)