UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7ajzJhQmYTCyuf8r2Ox3+tGV31OlZYAhyNjFb9BmMI='
WHERE
key_id = 'a7c943671a06ac3546dd5ad4cc3cb2df152061f7ab8406c5945d2ca1847206c3'
AND (
token = 'r7ajzJhQmYTCyuf8r2Ox3+tGV31OlZYAhyNjFb9BmMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)