UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W97SJzkkMfmJiNRWQII5VMwzUiQet635R1iNtghTDXk='
WHERE
key_id = 'ca7111b201b0572b7cbabc48b213ebfab15a1b6e265839d6a01d673df6f12d27'
AND (
token = 'W97SJzkkMfmJiNRWQII5VMwzUiQet635R1iNtghTDXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)