UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z39jxD3KZOxou0F7O1+qZZtae5jlsReY3qYfc6HO/tU='
WHERE
key_id = 'c95f2237e7b3ec3dacf62e32a10216965fe78aedf883a971007a3c160659bb5f'
AND (
token = 'z39jxD3KZOxou0F7O1+qZZtae5jlsReY3qYfc6HO/tU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)