UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVgN8U80BHpy2fIx3FqFVyz/L51j1EkHm3r+U+Haf24='
WHERE
key_id = '341a5a45a4295d2c9987b0fe8a70dc9c1accb8d5404386f848cf5c1e2149c466'
AND (
token = 'XVgN8U80BHpy2fIx3FqFVyz/L51j1EkHm3r+U+Haf24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)