UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RfNLtqMjiW+Vz/69GIdfEr7gDPlx/aZr/vuXYquA1vg='
WHERE
key_id = '05492d80cb2be3aaf1a875107189feb5e29342fec928112572e80d78ca37daee'
AND (
token = 'RfNLtqMjiW+Vz/69GIdfEr7gDPlx/aZr/vuXYquA1vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)