UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Xz6WNhQ24BrQznPp3YLRz5wG58zgxGgYTF2BQHgNqw='
WHERE
key_id = '16786605480e421db4671101ca7e5fa01062880b52289b7c1afe285c5e0a677e'
AND (
token = '7Xz6WNhQ24BrQznPp3YLRz5wG58zgxGgYTF2BQHgNqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)