UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3sSNa1BMwH1dJ9sfxNTEFFf3/WKAjL9uQkY4nr8Hub4='
WHERE
key_id = '4d67a8edb76d5c9b2cc53cedca3d28155f1e41e87c9bd3693570774065c9b6de'
AND (
token = '3sSNa1BMwH1dJ9sfxNTEFFf3/WKAjL9uQkY4nr8Hub4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)