UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4K7hcHvwBiHM0KfAY0zQ9CO1NlDbl0f1sR40JZVhHnI='
WHERE
key_id = 'ed8c8107c5d795cef840bce9104e7d7bc2a41b5856bef9a2ae44b4f0ee1ba373'
AND (
token = '4K7hcHvwBiHM0KfAY0zQ9CO1NlDbl0f1sR40JZVhHnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)