UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WEl9Kv871DKZPBNCKemgkVQF7K7UFd7Tz2tHctmi8pg='
WHERE
key_id = '50c149306f7addd391fd170e4cf775c0c9f45f323bd19605eccfd78873c98350'
AND (
token = 'WEl9Kv871DKZPBNCKemgkVQF7K7UFd7Tz2tHctmi8pg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)