UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xKK/rFSDGOf7WANYP1ZSK5C70wOjCrMUhszbhOmp2SA='
WHERE
key_id = '03cccaf5ba060d494de4d3914799682f725dda338639e5462671f6dfa97a38b9'
AND (
token = 'xKK/rFSDGOf7WANYP1ZSK5C70wOjCrMUhszbhOmp2SA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)