UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pf9XJVsD6qWvVtd1D3CYlk4D2ykhL03HvCZy06sRLbY='
WHERE
key_id = '9da4e4d06133fa3298384230104d0c58af42504572e42afdd1ce7e8a69295559'
AND (
token = 'pf9XJVsD6qWvVtd1D3CYlk4D2ykhL03HvCZy06sRLbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)