UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C0fIq8T5NM7lUgvxkYHvomhygEyzeUhE9/jZy7QLONU='
WHERE
key_id = '6c8f9c4fa9608c3437fce2a3540d29bbb0de62c51a45c32deb5277c2e7145cc1'
AND (
token = 'C0fIq8T5NM7lUgvxkYHvomhygEyzeUhE9/jZy7QLONU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)