UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVwHhyWu1OOR9yZFgI5j2IBUeTNtiilb/2q0WZpxChA='
WHERE
key_id = 'bb18c748c15e9bfc4664f9ef0e85878e752c7568fc4379093f27da945f340ec4'
AND (
token = 'XVwHhyWu1OOR9yZFgI5j2IBUeTNtiilb/2q0WZpxChA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)